Oracle/PLSQL Date Functions - PSOUG.org Returns the current date in the session time zone, in a value in the Gregorian calendar of ... In Oracle/PLSQL, the to_date function converts a string to a date.